﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DataAccess.Classes
{
  public  class ThongKe
  {
      public DataTable TableThongKe()
      {
          DataTable dtb = new DataTable();
          SqlConnection Conn = Helpers.GetSqlConnection();
          try
          {
              Conn.Open();
              DataSet ds = new DataSet();
              SqlCommand cmdUpd = new SqlCommand("spThongKe_Edit", Conn);
              cmdUpd.CommandType = CommandType.StoredProcedure;
              SqlDataAdapter da = new SqlDataAdapter(cmdUpd);
              da.Fill(ds);
              dtb = ds.Tables[0];
          }
          catch { }
          finally
          {
              if (Conn.State == ConnectionState.Open)
                  Conn.Close();
              Conn.Dispose();
          }
          return dtb;
      }
  }
}
